CREATE TABLE [dbo].[tb_ChequeosPorMovimiento]
(
[idChequeo] [int] NOT NULL IDENTITY(1, 1),
[Descripcion] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Movimiento] [int] NOT NULL,
[Licencia] [int] NULL,
[EsManual] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ControlAutomatico] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Permiso] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_ChequeosPorMovimiento] ADD CONSTRAINT [PK_tb_ChequeosPorMovimiento] PRIMARY KEY NONCLUSTERED  ([idChequeo]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_ChequeosPorMovimiento] WITH NOCHECK ADD CONSTRAINT [FK_tb_ChequeosPorMovimiento_tb_Licencias] FOREIGN KEY ([Licencia]) REFERENCES [dbo].[tb_Licencias] ([idLicencia])
GO
ALTER TABLE [dbo].[tb_ChequeosPorMovimiento] WITH NOCHECK ADD CONSTRAINT [FK_tb_ChequeosPorMovimiento_tb_Movimientos] FOREIGN KEY ([Movimiento]) REFERENCES [dbo].[tb_MovimientosDocentes] ([idMovimiento])
GO
